MacWorld 1998 January/Macworld (1998-01).dmg/FileMaker Pro 4/FM4 Templates w⁄data/Education/Loans

FileMaker Pro Database | 1997-09-14 | 103KB | 675 lines

HBAM2016AUG95
Pro 3.0
HBAM3016AUG95@
1/9/95
You can use this database to maintain information on items that have been loaned, such as software, CDs, books, sporting equipment, and musical instruments.
How to use this solution
You can add your school logo to the Overdue Items report and print an outstanding loan list.
How to customize this solution
You can use a relation to the Students file based on the Borrower ID field to display the First Name and Last Name, eliminating the need for duplicate data entry.
CHECK OUT PER
CREATED BY
DATE CHECK IN
DATE CHECK OUT
DATE DUE
DATE MODIFIED
DEP AMOUNT
DEP REFUNDED
FIRST NAME
ITEM DESCRIPTION
ITEM ID
C    ITEM TYPE
:    LAST NAME
OVERDUE CALC
I    RECORD ID
STUDENT ID
A    Record IDB
First NameB
Date ModifiedB
Date Check OutB
:A    Item TypeB
Date DueB
N - 1
BA    Last NameB
Item IDB
Dep AmountB
Dep RefundedB
Date Check InB
Item DescriptionB
Student IDB
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
11/20/95
Description
Use this database to maintain information on items that have been loaned, such as software, CDs, books, sporting equipment, and musical instruments.
How to use this solution
You can add your school logo to the Overdue Items report and print an outstanding loan list.
How to customize this solution
You can use a relation to the Students file based on the Borrower ID field to display the First Name and Last Name, eliminating the need for duplicate data entry.
A    Form View
A    List View
Overdue Items
Information
Report Menu
A    Form ViewB
Overdue CalcB
= > 0
 "Overdue"
 "")))
Overdue
InfoB
Check Out PerB
Created ByB
A    List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Deposit
Check In
Amount
Overdue?
    Check Out
Date Due
Description
Borrower
    Last Name
First Name
Enter data for Loaned Items
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
Loaned Items
Overdue ItemsB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Out[    Last Name\
First Name]
Description^
Item ID_
IDj/Click to see more information for a Loaned Itemk
Infol
Closem
View As
Formn
View As
Listo
Reportsp
Recordq
Delete
Recordr
Records
Your Own
Buttont
Your Own
Button
InformationB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Date Due
Date Out
O    Last Name
First Name
Description
Item ID
S    Record ID
Date Due
Date Out
O    Last Name
First Name
Description
Item ID
S    Record ID
Page ##
Overdue Items
Close
View As
View As
Reports
Your Own
Button
Report MenuB
P$Information about the Loans databaseQ
Info for this SolutionR
InfoS
CloseT
View As
FormU
View As
ListV
ReportsW
Your Own
Button
View As
FormU
View As
ListV
ReportsW
Your Own
Button
Your Own
ReportB
Your Own
ReportC
Your Own
ReportD
Overdue
ItemsL>Click on any of these buttons to preview the respective reportM
Select a reportN
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
on any of these buttons to preview the respective reportM
Select a reportN
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
SoniaY
11/20/95p
3/4/96z
Sports Equipment}
3/4/96
Soccer Ball
SoniaY
11/20/95p
3/5/96z
Book}
3/14/96
31526
The Grapes of Wrath
MartinY
11/20/95p
3/11/96z
Musical Instrument}
3/17/96
Chester
Refunded
3/18/96
LorindaY
11/20/95p
3/18/96z
Software}
3/19/96
Dobbs
FileMaker Pro
Sort by Record ID
Sort by Item ID
Sort by Item Description
Sort by Last Name
Sort by Date Checked Out
InfoT
CloseU
View As
FormV
View As
ListW
ReportsX
Your Own
Button
Yesfter
Noarter
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Terminal
Sort by Last Name
Overdue Items
Sort by Record ID
Sort by Item ID
Sort by Item Description
Sort by Date Checked Out
Sort by Date Checked In
Open Script
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C+
) = 0
Cancel
No records match this request.E+
) = 1
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
(LIST
LISTAPAudio CD
Audio Tape
Musical Instrument
Software
Sports Equipment
Video Tape
VDEFA(
(LIST
LISTA
Refunded
VDEFA(
Item Type ListB
Deposit Refunded List
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
wwwwww
    ffffff
UUUUUU
DDDDDD
333333
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
    ffffff
UUUUUU
DDDDDD
333333
#4EWp
"4EVx
#3EVg
"4DUg
#3EVg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
"%UR
UD33D
AD@D@
AD@D@
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
bRBBP0
@@BA@
(*)(%,3&
)%+@6)
",30,)%
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*
!$&(265389,#!$$
'275?
" $$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+,)+"
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!PQ
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGCA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,027CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
876=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,
169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7)
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,
M4%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
UUUUUU
wwwwww
Sort by Date Checked In
Overdue Items
Open Script
Pro 2.0 - 2.1F!
Pro 3.0